Swiss Covid Wastewater Virus Load Data
Kaspar V.
2023-04-19
Information
This document is a personal throw together to get some personal
insight into the COVID-19 wastewater virus load data.
The original data was published by the Swiss Federal Office of Public
Health.
- Covid-19 – Viruslast im Abwasser – Bundesamt für Gesundheit BAG
- Data
source website - opendata.swiss
- Data model documentation
- Source document (CSV ~5.5MB)
- Source of this document (R Markdown)
Available Localities
Sorted by wastewater facility population reach.
More localities can be added to the plot_localities chunk,
as demonstrated in the already present plots.
See: Source of this document (R Markdown)
| geoRegion | name | canton | pop |
|---|---|---|---|
| 26101 | Werdhölzli | ZH | 471000 |
| 664301 | Aire | GE | 451771 |
| 270101 | Basel | BS | 273075 |
| 558600 | Lausanne (Vidy) | VD | 247824 |
| 35100 | Region Bern | BE | 224557 |
| 102400 | Buholz (Real) | LU | 183511 |
| 170200 | Cham (Schoenau) | ZG | 146942 |
| 23001 | Winterthur | ZH | 140403 |
| 94400 | Thunersee | BE | 124550 |
| 515100 | Lugano | TI | 124000 |
| 296300 | Ramsen (Bibertal-Hegau) | SH | 100338 |
| 253400 | Zuchwil (Soloth.-Emme) | SO | 95793 |
| 73300 | Biel | BE | 85389 |
| 24301 | Dietikon (Limeco) | ZH | 83367 |
| 276600 | Birs | BL | 83312 |
| 663801 | Satigny/Bois-de-Bay | GE | 79577 |
| 400100 | Aarau | AG | 78255 |
| 36200 | Worblental | BE | 71636 |
| 323700 | Altenrhein | SG | 64000 |
| 66700 | Laupen | BE | 62000 |
| 404200 | Baden | AG | 59560 |
| 320401 | St.Gallen (Hofen) | SG | 57031 |
| 293700 | Neuhausen A/Rhf. (Roeti) | SH | 56967 |
| 390101 | Chur | GR | 55000 |
| 420300 | Lenzburg | AG | 54568 |
| 250100 | Winznau (Zv Olten) | SO | 54540 |
| 589000 | Vevey (Aviron) | VD | 53864 |
| 500200 | Bellinzona (Giubiasco) | TI | 53209 |
| 664000 | Thonex/Villette | GE | 51028 |
| 511302 | Locarno (Foce Maggia) | TI | 50781 |
| 160200 | Glarnerland | GL | 49644 |
| 254600 | Grenchen (Buerenamt) | SO | 46563 |
| 412300 | Brugg | AG | 46250 |
| 219600 | Fribourg (Aele) | FR | 44211 |
| 8901 | Niederglatt (Fischb.-Gl.) | ZH | 43596 |
| 588600 | Montreux/Pierrier | VD | 41383 |
| 19801 | Uster (Jungholz) | ZH | 41303 |
| 323100 | Au (Rosenbergsau) | SG | 41281 |
| 32101 | Aarwangen (Zala) | BE | 40845 |
| 645800 | Neuchatel | NE | 40697 |
| 613600 | Martigny | VS | 39643 |
| 19101 | Dübendorf (Ika Neugut) | ZH | 39622 |
| 100000 | Liechtenstein | FL | 39315 |
| 564200 | Morges | VD | 39126 |
| 320302 | St.Gallen (Au) | SG | 37876 |
| 282500 | Ergolz 2 | BL | 37565 |
| 670900 | Delemont (Sede) | JU | 36484 |
| 40100 | Burgdorf | BE | 36465 |
| 456600 | Frauenfeld | TG | 36369 |
| 30600 | Lyss | BE | 36358 |
| 572100 | Gland (Apec) | VD | 36034 |
| 626601 | Sion/Chateauneuf | VS | 35632 |
| 5301 | Bülach | ZH | 35612 |
| 428000 | Zofingen | AG | 35577 |
| 593800 | Yverdon | VD | 35462 |
| 642100 | La-Chaux-de-Fonds | NE | 35360 |
| 216100 | Vuippens (Ais) | FR | 34647 |
| 120101 | Altdorf | UR | 33940 |
| 41100 | Moossee-Urtenenbach | BE | 33844 |
| 624801 | Sierre/Noes | VS | 32480 |
| 408200 | Wohlen | AG | 31992 |
| 12101 | Wetzikon (Flos) | ZH | 31419 |
| 494600 | Weinfelden (Mittelthurgau) | TG | 31342 |
| 137200 | Schwyz | SZ | 31164 |
| 427100 | Aarburg | AG | 30884 |
| 321700 | Steinach (Morgental) | SG | 30710 |
| 140100 | Alpnach (Sarneraatal) | OW | 30657 |
| 340200 | Flawil (Oberglatt) | SG | 30378 |
| 201 | Affoltern am Albis | ZH | 30226 |
| 132200 | Hoefe | SZ | 29624 |
| 134400 | Untermarch | SZ | 29470 |
| 526200 | Mendrisio (Rancate) | TI | 29392 |
| 286100 | Ergolz 1 | BL | 29168 |
| 106500 | Rontal | LU | 28771 |
| 600200 | Brig-Glis (Briglina) | VS | 28678 |
| 333500 | Rapperswil-Jona | SG | 28168 |
| 59300 | Interlaken | BE | 27945 |
| 640600 | Colombier (La Saunerie) | NE | 27582 |
| 13301 | Horgen | ZH | 26952 |
| 526800 | Chiasso (Vacallo) | TI | 26638 |
| 15601 | Meilen (Rorguet) | ZH | 26447 |
| 342500 | Wil | SG | 26295 |
| 283100 | Pratteln/Rhein | BL | 26286 |
| 572400 | Nyon | VD | 25753 |
| 95600 | Mittl. Emmental | BE | 25733 |
| 416900 | Kaisten | AG | 25354 |
| 277500 | Birsig | BL | 24943 |
| 327100 | Buchs | SG | 24844 |
| 511301 | Locarno (Foce Ticino) | TI | 24516 |
| 279300 | Zwingen (Laufental-L-Tal) | BL | 24357 |
| 414100 | Reinach | AG | 23817 |
| 441600 | Hefenhofen (Aachtal, Moos) | TG | 23074 |
| 406300 | Bremgarten | AG | 22613 |
| 571100 | Commugny | VD | 22575 |
| 150900 | Stans (Rotzwinkel) | NW | 21214 |
| 17401 | Illnau-Effretikon | ZH | 18921 |
| 395501 | Landquart | GR | 17054 |
| 300102 | Herisau (Bachwis) | AR | 16500 |
| 680000 | Porrentruy (Sepe) | JU | 16500 |
| 378802 | S-chanf (Oberengadin) | GR | 15056 |
| 297100 | Hallau (Klettgau) | SH | 14795 |
| 329200 | Flums (Seez) | SG | 12448 |
| 329100 | Bad Ragaz | SG | 12007 |
| 310100 | Appenzell (Boedeli) | AI | 11877 |
| 366101 | Cazis (Waldau) | GR | 10963 |
| 385102 | Davos (Gadenstatt) | GR | 9706 |
| 84300 | Saanen | BE | 9253 |
| 397201 | Seewis (Vorderes Prättigau) | GR | 8003 |
| 358201 | Schluein (Gruob) | GR | 7823 |
| 603102 | Bagnes-Le Châble | VS | 7713 |
| 3001 | Andelfingen | ZH | 7150 |
| 630000 | Zermatt | VS | 5507 |
| 605700 | Goms | VS | 4193 |
| 57600 | Grindelwald | BE | 4153 |
| 140200 | Engelberg | OW | 4053 |
| 376201 | Scuol (Sot Ruinas) | GR | 3473 |
| 356101 | Poschiavo (Li Geri) | GR | 3358 |
| 387101 | Klosters (Gulfia) | GR | 3155 |
| 58400 | Lauterbrunnen | BE | 2553 |
| 392101 | Arosa | GR | 2049 |
Contribute
My knowledge of R is extremely limited.
I’ve chunked this document together quickly, and I may have done some
ugly things for your R experts taste.
Contributions by someone with more R expertise than myself (likely anyone with R knowledge) are, of course, highly welcome.